Purpose
NOTE: ORIGINAL variation with origin verbose/repeated code partially replaced with functions - key for archival purposes.
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Method
- Log into crypto account.
- Download activity report.
- Go to spreadsheet in Marengo - check most recent transaction date there.
- Copy/paste new transactions from activity report.
- Copy down formulas in spreadsheet.
Bitcoin
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
Adjusted Cost Base (Avg Cost)
Cardano
Adjusted Cost Base (Avg Cost)
Polkadot
Adjusted Cost Base (Avg Cost)
Litecoin
Adjusted Cost Base (Avg Cost)
TOTALS

|
date
|
currency
|
book_val
|
market_val
|
profit
|
roi
|
|
2021-10-16
|
BTC
|
$3,177
|
$5,014
|
1,837
|
58%
|
|
2021-10-16
|
ETH
|
$5,954
|
$17,229
|
11,275
|
189%
|
|
2021-10-16
|
ADA
|
$4,092
|
$3,790
|
(303)
|
-7%
|
|
2021-10-16
|
DOT
|
$2,535
|
$3,615
|
1,081
|
43%
|
|
2021-10-16
|
LTC
|
$2,305
|
$2,327
|
22
|
1%
|
|
date
|
total_invested
|
total_market_val
|
total_profit
|
total_roi
|
|
2021-10-16
|
$18,063
|
$31,975
|
$13,912
|
77%
|